Excel Example

Cumulative Frequency Graph

Step 1: Enter your frequency table as midpoints in one column and frequency in another.

excel cumulative frequency graph step 1

Step 2: Select "insert" in the top menu and highlight your data by clicking and dragging.

excel cumulative frequency graph example step 2

Step 3: Select "scatter" from the top menu

excel cumulative frequency graph step 3

Step 4: From the dropdown menu select scatter plot with straight lines

Excel Cumulative Frequency example step 4

Step 5: right click graph the select "format" for more options

excel cumulative frequency example step 5

Step 6: You may need to change where the the \(x\) or \(y\) axis starts or begins to make a cleaner picture, you can also change the size and color of the dots etc.

excel cumulative frequency graph example step 6

To see this done watch the following video: